home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Borland / Borland C++ V5.02 / 32QUERY.PAK / JOIN.SQL < prev    next >
Text File  |  1997-05-06  |  126b  |  3 lines

  1. select c.name, c.city, o.'total invoice', o.'amount paid'
  2. from "cust.dbf" c, "orders.db" o
  3. where c.'cust_no' = o.'customer no'